Tabela ExternalDoctor

Definicja tabeli ExternalDoctor

Name

ExternalDoctor

Code

ExternalDoctor

Comment

 


Lista kolumn tabeli ExternalDoctor

Name

Code

ExternalDoctorID

ExternalDoctorID

AddressID

AddressID

ExternalDoctorTypeID

ExternalDoctorTypeID

PersonID

PersonID

Code

Code

Title

Title

CTitle

CTitle

FirstName

FirstName

MiddleName

MiddleName

LastName

LastName

OrderingDoctorNo

OrderingDoctorNo

LicenceNo

LicenceNo

Active

Active

Comments

Comments


Kolumna ExternalDoctorID tabeli ExternalDoctor

Definicja kolumny ExternalDoctorID tabeli ExternalDoctor

Name

ExternalDoctorID

Code

ExternalDoctorID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AddressID tabeli ExternalDoctor

Definicja kolumny AddressID tabeli ExternalDoctor

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalDoctorTypeID tabeli ExternalDoctor

Definicja kolumny ExternalDoctorTypeID tabeli ExternalDoctor

Name

ExternalDoctorTypeID

Code

ExternalDoctorTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli ExternalDoctor

Definicja kolumny PersonID tabeli ExternalDoctor

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Code tabeli ExternalDoctor

Definicja kolumny Code tabeli ExternalDoctor

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna Title tabeli ExternalDoctor

Definicja kolumny Title tabeli ExternalDoctor

Name

Title

Code

Title

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna CTitle tabeli ExternalDoctor

Definicja kolumny CTitle tabeli ExternalDoctor

Name

CTitle

Code

CTitle

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna FirstName tabeli ExternalDoctor

Definicja kolumny FirstName tabeli ExternalDoctor

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna MiddleName tabeli ExternalDoctor

Definicja kolumny MiddleName tabeli ExternalDoctor

Name

MiddleName

Code

MiddleName

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna LastName tabeli ExternalDoctor

Definicja kolumny LastName tabeli ExternalDoctor

Name

LastName

Code

LastName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna OrderingDoctorNo tabeli ExternalDoctor

Definicja kolumny OrderingDoctorNo tabeli ExternalDoctor

Name

OrderingDoctorNo

Code

OrderingDoctorNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna LicenceNo tabeli ExternalDoctor

Definicja kolumny LicenceNo tabeli ExternalDoctor

Name

LicenceNo

Code

LicenceNo

Data Type

VARCHAR2(8)

Mandatory

No

Comment

 


Kolumna Active tabeli ExternalDoctor

Definicja kolumny Active tabeli ExternalDoctor

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Comments tabeli ExternalDoctor

Definicja kolumny Comments tabeli ExternalDoctor

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli ExternalDoctor

Name

Code

Primary

PK_EXTERNALDOCTOR

PK_EXTERNALDOCTOR

X


Klucz PK_EXTERNALDOCTOR tabeli ExternalDoctor

Definicja klucza PK_EXTERNALDOCTOR tabeli ExternalDoctor

Name

PK_EXTERNALDOCTOR

Code

PK_EXTERNALDOCTOR

Primary

Yes

Comment